using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using EcsSiteDSTableAdapters;
using System.ComponentModel;

/// <summary>
/// Summary description for CityBLL
/// </summary>
namespace SiteECSWeb
{
    [DataObject]
    public class CityBLL
    {
        private CityTableAdapter _CityAdapter = null;

        protected CityTableAdapter CityAdapter
        {
            get
            {
                if (_CityAdapter == null)
                {
                    _CityAdapter = new CityTableAdapter();
                }
                return _CityAdapter;
            }
        }
        #region SelectCityData
        [DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
        public EcsSiteDS.CityDataTable GetALLCityByCityID(int City_id)
        {
            return CityAdapter.GetCityDataByCityID(City_id);
        }
        [DataObjectMethodAttribute(DataObjectMethodType.Select, false)]
        public EcsSiteDS.CityDataTable GetAllCityWithFirstLetter(string City_nmen)
        {
            return CityAdapter.GetCityDataByCityNmEnFrstLetter(City_nmen);
        }

        [DataObjectMethodAttribute(DataObjectMethodType.Select, false)]
        public EcsSiteDS.CityDataTable GetCityWithNmEn(string City_nmen)
        {
            return CityAdapter.GetCityDataByCityNmEn(City_nmen);
        }
        [DataObjectMethodAttribute(DataObjectMethodType.Select, false)]
        public EcsSiteDS.CityDataTable GetEgyptCities()
        {
            return CityAdapter.GetCityDataByContryUn2EG();
        }


    
        #endregion

    }
}
